﻿namespace LanSunERP
{
    using System;
    using System.ServiceModel;
    using System.Windows.Forms;
    using System.Diagnostics;
    using System.Collections.Generic;
    using System.Runtime.Serialization;
    using System.Collections;
    using System.Data;
    using System.Data.SqlClient;

    public class Weave_Base : QueryCommand
    {
        public Weave_Base() : base() { }
        public Weave_Base(SqlCommand cmdSQL, DataTable dtRequest, string RequestJob)
            : base(cmdSQL, dtRequest, RequestJob) { }
        public SqlCommand BuildCommand()
        {
           switch (RequestJob.Substring(6, 10))
            {
                case "0000": break;
                case "1000": break;
                case "1001":
                    cmdSQL.Parameters.Add(new SqlParameter("@SysID", dwRequest["SysID"].ToString()));
                    break;
                case "1002": break;
                case "1003": break;
                case "1004": break;
                case "1005": break;
                case "2000": 
                case "3000":
                    cmdSQL.Parameters.Add(new SqlParameter("@SysID", dwRequest["SysID"].ToString()));
                    cmdSQL.Parameters.Add(new SqlParameter("@InstanceID", dwRequest["InstanceID"].ToString()));
                    cmdSQL = BuildInstanceKey(cmdSQL, dwRequest);
                    cmdSQL.Parameters.Add(new SqlParameter("@GoodsKeyInstanceID", dwRequest["GoodsKeyInstanceID"].ToString()));
                    cmdSQL.Parameters.Add(new SqlParameter("@GoodsKeyInstanceKey", dwRequest["GoodsKeyInstanceKey"].ToString()));
                    cmdSQL.Parameters.Add(new SqlParameter("@PositionID", dwRequest["PositionID"].ToString()));
                    cmdSQL.Parameters.Add(new SqlParameter("@Weave", dwRequest["Weave"].ToString()));
                    cmdSQL.Parameters.Add(new SqlParameter("@ExtenedProperty", dwRequest["ExtenedProperty"].ToString()));
                    cmdSQL.Parameters.Add(new SqlParameter("@SubStatus", dwRequest["SubStatus"].ToString()));
                    cmdSQL.Parameters.Add(new SqlParameter("@Status", dwRequest["Status"].ToString()));
                    
                    break;
                case "2001":case "4000":
                    cmdSQL.Parameters.Add(new SqlParameter("@InstanceID", dwRequest["InstanceID"].ToString()));
                    break;
            
            }
            return cmdSQL;

        }

    }
}